<%--
    Document   : temp
    Created on : Oct 4, 2012, 4:10:02 PM
    Author     : MinhThang
--%>

<%@page import="org.apt.connectDB.MyConnect"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>National Level Paper Presentation</title>
        <link href="style/css/transdmin.css" rel="stylesheet" type="text/css" media="screen" />
        <!--[if IE 6]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie6.css" /><![endif]-->
        <!--[if IE 7]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie7.css" /><![endif]-->

        <!-- JavaScripts-->
        <script type="text/javascript" src="style/js/jquery.js"></script>
        <script type="text/javascript" src="style/js/jNice.js"></script>
    </head>
    <body>
        <%
                    if (session.getAttribute("AdminUser") == null || session.getAttribute("AdminUser").toString() == "") {
                        response.sendRedirect("/Admin/adminlogin.jsp");
                    }
        %>
        <div id="wrapper">
            <h1><a href="#"><span>Admin Paper Presentation</span></a></h1>
            <div><%@include file="Template/header.jsp" %></div>
            <div id="containerHolder">
                <div id="sidebar">
                    <ul class="sideNav">
                        <li class="limenu"><a href="create_lecture.jsp">Create a lecture</a></li>
                        <li class="limenu"><a href="list_author_lecture.jsp">List Author</a></li>
                        <li class="limenu"><a href="create_author_lecture.jsp">Create author</a></li>
                        <li class="limenu"><a href="create_lecture_event.jsp">Create Lecture event</a></li>
                        <li class="limenu"><a href="event_and_lecture.jsp">Event and lecture</a></li>
                    </ul>
                    <!-- // .sideNav -->
                </div>
                <h2><a href="#">Lecture >></a> <a href="#" class="active">Lecture in event</a></h2>
                <div id="main">
                    <form action="lectureinevent.do" method="post">
                        <%
                                    //display data
                                    Connection conn = null;
                                    PreparedStatement ps = null;
                                    String sql = "Select * from LectureEvent where EventID=?";
                                    String sql2 = "SELECT LectureID,Title  FROM Lecture where LectureID NOT IN ( select LectureID from LectureJoin where EventID = ?)";
                                    String sql3 = "SELECT LectureID,Title  FROM Lecture where LectureID IN ( select LectureID from LectureJoin where EventID = ?)";
                                    ResultSet rs = null;
                                    try {
                                        conn = MyConnect.getConnection();
                                        ps = conn.prepareCall(sql);
                                        ps.setInt(1, Integer.parseInt(request.getParameter("ID")));
                                        rs = ps.executeQuery();
                                        while (rs.next()) {
                                            boolean status = rs.getBoolean("Status");
                                            String tus = "Active";
                                            if (status == true) {
                                                tus = "Un-Active";
                                            }
                        %>
                        <table>
                            <tr>
                                <td style="font-size: 1.5em;"><b><%=rs.getString("EventName").toString()%></b>
                                    <input type="hidden" name="txtEventID" value="<%=request.getParameter("ID").toString()%>"/>
                                </td>
                            </tr>
                            <tr>
                                <td>Location :<%=rs.getString("Location").toString()%></td>
                            </tr>
                            <tr>
                                <td>Start hour :<%=rs.getString("Start").toString()%></td>
                            </tr>
                            <tr>
                                <td>End hour :<%=rs.getString("End").toString()%></td>
                            </tr>
                            <tr>
                                <td>Price :<%=rs.getString("PriceJoin").toString()%></td>
                            </tr>
                            <tr>
                                <td>Status : <%=tus%></td>
                            </tr>
                            <tr>
                                <td><h3>Choose lecture</h3></td></tr>
                            <tr>
                                <td>
                                    <select name="ddlLecture" style="width: 150px;">
                                        <option value="-1">Choose a lecture</option>
                                        <%
                                                                        ps = conn.prepareCall(sql2);
                                                                        ps.setInt(1, Integer.parseInt(request.getParameter("ID")));
                                                                        rs = ps.executeQuery();
                                                                        while (rs.next()) {
                                        %>
                                        <option value="<%=rs.getString("LectureID").toString()%>"><%=rs.getString("Title").toString()%></option>
                                        <%}
                                        %>

                                    </select>
                                </td>
                            </tr>
                            <tr>
                                <td><h3>List lecture in event</h3></td>
                                <%
                                                                ps = conn.prepareCall(sql3);
                                                                ps.setInt(1, Integer.parseInt(request.getParameter("ID")));
                                                                rs = ps.executeQuery();
                                                                while (rs.next()) {
                                %>
                            <tr><td><%=rs.getString("Title").toString()%></td></tr>
                            <%}
                            %>
                            <tr>
                                <td><input type="submit" value="Create speaker" /></td>
                            </tr>
                        </table>
                        <%
                                        }
                                    } catch (Exception e) {
                                        e.printStackTrace();
                                    }
                        %>
                    </form>
                </div>
                <!-- // #main -->
                <div class="clear"></div>
            </div>
        </div>
    </body>
</html>
